<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  

  
  <title>一起学Excel</title>
  <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
  <meta property="og:type" content="website">
<meta property="og:title" content="一起学Excel">
<meta property="og:url" content="https://lecoder.gitee.io/study-excel/page/74/index.html">
<meta property="og:site_name" content="一起学Excel">
<meta property="og:locale" content="zh_CN">
<meta property="article:author" content="lijile">
<meta name="twitter:card" content="summary">
  
  
    <link rel="icon" href="/favicon.png">
  
  
    <link href="//fonts.googleapis.com/css?family=Source+Code+Pro" rel="stylesheet" type="text/css">
  
  
<link rel="stylesheet" href="/study-excel/css/style.css">

<meta name="generator" content="Hexo 6.3.0"></head>

<body>
  <div id="container">
    <div id="wrap">
      <header id="header">
  <div id="banner"></div>
  <div id="header-outer" class="outer">
    <div id="header-title" class="inner">
      <h1 id="logo-wrap">
        <a href="/study-excel/" id="logo">一起学Excel</a>
      </h1>
      
    </div>
    <div id="header-inner" class="inner">
      <nav id="main-nav">
        <a id="main-nav-toggle" class="nav-icon"></a>
        
          <a class="main-nav-link" href="/study-excel/">Home</a>
        
          <a class="main-nav-link" href="/study-excel/archives">Archives</a>
        
      </nav>
      <nav id="sub-nav">
        
        <a id="nav-search-btn" class="nav-icon" title="搜索"></a>
      </nav>
      <div id="search-form-wrap">
        <form action="//google.com/search" method="get" accept-charset="UTF-8" class="search-form"><input type="search" name="q" class="search-form-input" placeholder="Search"><button type="submit" class="search-form-submit">&#xF002;</button><input type="hidden" name="sitesearch" value="https://lecoder.gitee.io/study-excel"></form>
      </div>
    </div>
  </div>
</header>
      <div class="outer">
        <section id="main">
  
    <article id="post-excel-2010-new-functions" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-2010-new-functions/" class="article-date">
  <time datetime="2022-11-23T07:04:54.100Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/">基础</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/">新增功能和函数</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/Excel-2010/">Excel 2010</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-2010-new-functions/">Excel 2010 – 新增函数</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <h2 id="日期和时间函数"><a href="#日期和时间函数" class="headerlink" title="日期和时间函数"></a>日期和时间函数</h2><h3 id="NETWORKDAYS-INTL函数"><a href="#NETWORKDAYS-INTL函数" class="headerlink" title="NETWORKDAYS.INTL函数"></a>NETWORKDAYS.INTL函数</h3><p>NETWORKDAYS.INTL 函数返回两个日期之间除指定的周末和假期外的工作日数量（包括起始和结束日期）。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=NETWORKDAYS.INTL(start_date, end_date,[weekend], [holidays])</span><br><span class="line">=NETWORKDAYS.INTL(起始日期,结束日期, [周末类型], [假期])</span><br></pre></td></tr></table></figure>

<h3 id="WORKDAY-INTL函数"><a href="#WORKDAY-INTL函数" class="headerlink" title="WORKDAY.INTL函数"></a>WORKDAY.INTL函数</h3><p>WORKDAY.INTL 函数返回在给定起始日期之前或之后，与该日期相隔给定的工作日的日期。其中，工作日不包括周末和给定的假期，周末类型可以自定义。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=WORKDAY.INTL(start_date,days, [weekend], [holidays])</span><br><span class="line">=WORKDAY.INTL(起始日期, 工作日, [周末类型], [假期])</span><br></pre></td></tr></table></figure>

<p> </p>
<h2 id="工程函数"><a href="#工程函数" class="headerlink" title="工程函数"></a>工程函数</h2><h3 id="ERF-PRECISE函数"><a href="#ERF-PRECISE函数" class="headerlink" title="ERF.PRECISE函数"></a>ERF.PRECISE函数</h3><p>ERF.PRECISE 函数返回误差函数的积分。语法如下：</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=ERF.PRECISE(x)</span><br></pre></td></tr></table></figure>

<h3 id="ERFC-PRECISE函数"><a href="#ERFC-PRECISE函数" class="headerlink" title="ERFC.PRECISE函数"></a>ERFC.PRECISE函数</h3><p>ERFC.PRECISE 函数返回从指定下限值到无穷大积分的互补 ERF 函数。语法如下：</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=ERFC.PRECISE(x)</span><br></pre></td></tr></table></figure>

<p> </p>
<h2 id="统计函数"><a href="#统计函数" class="headerlink" title="统计函数"></a>统计函数</h2><h3 id="BETA-DIST-函数"><a href="#BETA-DIST-函数" class="headerlink" title="BETA.DIST 函数"></a>BETA.DIST 函数</h3><p>BETA.DIST 函数返回 Beta 分布。Beta 分布通常用于研究样本中一定部分的变化情况。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=BETA.DIST(x,alpha,beta,cumulative,[A],[B])</span><br></pre></td></tr></table></figure>

<h3 id="BETA-INV-函数"><a href="#BETA-INV-函数" class="headerlink" title="BETA.INV 函数"></a>BETA.INV 函数</h3><p>BETA.INV 函数返回 Beta 累积概率密度函数（BETA.DIST）的反函数。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=BETA.INV(probability,alpha,beta,[A],[B])</span><br></pre></td></tr></table></figure>

<h3 id="BINOM-DIST-函数"><a href="#BINOM-DIST-函数" class="headerlink" title="BINOM.DIST 函数"></a>BINOM.DIST 函数</h3><p>BINOM.DIST 函数返回一元二项式分布的概率。该函数用于处理固定次数的试验或实验问题，前提是任意试验的结果仅为成功或失败两种情况，实验是独立实验，且在整个试验过程中成功的概率固定不变。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=BINOM.DIST(number_s,trials, probability_s, cumulative)</span><br></pre></td></tr></table></figure>

<h3 id="BINOM-INV-函数"><a href="#BINOM-INV-函数" class="headerlink" title="BINOM.INV 函数"></a>BINOM.INV 函数</h3><p>BINOM.INV 函数使得累积二项式分布的函数值≥临界值的最小整数的数值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=BINOM.INV(trials,probability_s,alpha)</span><br></pre></td></tr></table></figure>

<h3 id="CHISQ-DIST-函数"><a href="#CHISQ-DIST-函数" class="headerlink" title="CHISQ.DIST 函数"></a>CHISQ.DIST 函数</h3><p>CHISQ.DIST 函数返回卡方分布（Chi-Square Distribution）。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=CHISQ.DIST(x,deg_freedom,cumulative)</span><br></pre></td></tr></table></figure>

<h3 id="CHISQ-DIST-RT-函数"><a href="#CHISQ-DIST-RT-函数" class="headerlink" title="CHISQ.DIST.RT 函数"></a>CHISQ.DIST.RT 函数</h3><p>CHISQ.DIST.RT 函数返回卡方分布（Chi-Square Distribution）的右尾概率。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=CHISQ.DIST.RT(x,deg_freedom)</span><br></pre></td></tr></table></figure>

<h3 id="CHISQ-INV-函数"><a href="#CHISQ-INV-函数" class="headerlink" title="CHISQ.INV 函数"></a>CHISQ.INV 函数</h3><p>CHISQ.INV 函数返回卡方分布（Chi-Square Distribution）的左尾概率的反函数。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=CHISQ.INV(probability,deg_freedom)</span><br></pre></td></tr></table></figure>

<h3 id="CHISQ-INV-RT-函数"><a href="#CHISQ-INV-RT-函数" class="headerlink" title="CHISQ.INV.RT 函数"></a>CHISQ.INV.RT 函数</h3><p>CHISQ.INV.RT 函数返回卡方分布（Chi-Square Distribution）的右尾概率的反函数。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=CHISQ.INV.RT(probability,deg_freedom)</span><br></pre></td></tr></table></figure>

<h3 id="CHISQ-TEST-函数"><a href="#CHISQ-TEST-函数" class="headerlink" title="CHISQ.TEST 函数"></a>CHISQ.TEST 函数</h3><p>CHISQ.TEST 函数返回独立性检验值。返回卡方分布的统计值和相应的自由度数。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=CHISQ.TEST(actual_range,expected_range)</span><br></pre></td></tr></table></figure>

<h3 id="CONFIDENCE-NORM-函数"><a href="#CONFIDENCE-NORM-函数" class="headerlink" title="CONFIDENCE.NORM 函数"></a>CONFIDENCE.NORM 函数</h3><p>CONFIDENCE.NORM 函数使用正态分布返回总体平均值的置信区间。置信区间为某一范围的值。 样本平均值 x 位于此范围的中心，此范围为 x± CONFIDENCE.NORM。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=CONFIDENCE.NORM(alpha,standard_dev,size)</span><br></pre></td></tr></table></figure>

<h3 id="CONFIDENCE-T-函数"><a href="#CONFIDENCE-T-函数" class="headerlink" title="CONFIDENCE.T 函数"></a>CONFIDENCE.T 函数</h3><p>CONFIDENCE.T 函数使用学生 t-分布（Student’st-distribution）返回总体平均值的置信区间。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=CONFIDENCE.T(alpha,standard_dev,size)</span><br></pre></td></tr></table></figure>

<h3 id="COVARIANCE-P-函数"><a href="#COVARIANCE-P-函数" class="headerlink" title="COVARIANCE.P 函数"></a>COVARIANCE.P 函数</h3><p>COVARIANCE.P 函数返回总体协方差，即两组数据中每对数据的偏差乘积的平均数。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=COVARIANCE.P(array1,array2)</span><br><span class="line">=COVARIANCE.P(数组1, 数组2)</span><br></pre></td></tr></table></figure>

<h3 id="COVARIANCE-S-函数"><a href="#COVARIANCE-S-函数" class="headerlink" title="COVARIANCE.S 函数"></a>COVARIANCE.S 函数</h3><p>COVARIANCE.S 函数返回样本协方差，即两组数据中每对数据的偏差乘积的平均数。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=COVARIANCE.S(array1,array2)</span><br><span class="line">=COVARIANCE.S(数组1, 数组2)</span><br></pre></td></tr></table></figure>

<h3 id="EXPON-DIST-函数"><a href="#EXPON-DIST-函数" class="headerlink" title="EXPON.DIST 函数"></a>EXPON.DIST 函数</h3><p>EXPON.DIST 函数返回指数分布。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=EXPON.DIST(x,lambda, cumulative)</span><br></pre></td></tr></table></figure>

<h3 id="F-DIST-函数"><a href="#F-DIST-函数" class="headerlink" title="F.DIST 函数"></a>F.DIST 函数</h3><p>F.DIST 函数返回F分布。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=F.DIST(x,deg_freedom1,deg_freedom2,cumulative)</span><br></pre></td></tr></table></figure>

<h3 id="F-DIST-RT-函数"><a href="#F-DIST-RT-函数" class="headerlink" title="F.DIST.RT 函数"></a>F.DIST.RT 函数</h3><p>F.DIST.RT 函数返回右尾F概率分布。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=F.DIST.RT(x,deg_freedom1,deg_freedom2)</span><br></pre></td></tr></table></figure>

<h3 id="F-INV-函数"><a href="#F-INV-函数" class="headerlink" title="F.INV 函数"></a>F.INV 函数</h3><p>F.INV 函数返回F概率分布函数的反函数。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=F.INV(probability,deg_freedom1,deg_freedom2)</span><br></pre></td></tr></table></figure>

<h3 id="F-INV-RT-函数"><a href="#F-INV-RT-函数" class="headerlink" title="F.INV.RT 函数"></a>F.INV.RT 函数</h3><p>F.INV.RT 函数返回右尾F概率分布函数的反函数。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=F.INV.RT(probability,deg_freedom1,deg_freedom2)</span><br></pre></td></tr></table></figure>

<h3 id="F-TEST-函数"><a href="#F-TEST-函数" class="headerlink" title="F.TEST 函数"></a>F.TEST 函数</h3><p>F.TEST 函数返回F检验结果，即当两组数据的方差无明显差异时的双尾概率。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=F.TEST(array1,array2)</span><br></pre></td></tr></table></figure>

<h3 id="GAMMA-DIST-函数"><a href="#GAMMA-DIST-函数" class="headerlink" title="GAMMA.DIST 函数"></a>GAMMA.DIST 函数</h3><p>GAMMA.DIST 函数返回 GAMMA 函数的值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=GAMMA.DIST(x,alpha,beta,cumulative)</span><br></pre></td></tr></table></figure>

<h3 id="GAMMA-INV-函数"><a href="#GAMMA-INV-函数" class="headerlink" title="GAMMA.INV 函数"></a>GAMMA.INV 函数</h3><p>GAMMA.INV 函数返回 GAMMA 函数的反函数值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=GAMMA.INV(probability,alpha,beta)</span><br></pre></td></tr></table></figure>

<h3 id="GAMMALN-函数"><a href="#GAMMALN-函数" class="headerlink" title="GAMMALN 函数"></a>GAMMALN 函数</h3><p>GAMMALN 函数返回GAMMA函数的自然对数。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=GAMMALN.PRECISE(x)</span><br></pre></td></tr></table></figure>

<h3 id="HYPGEOM-DIST-函数"><a href="#HYPGEOM-DIST-函数" class="headerlink" title="HYPGEOM.DIST 函数"></a>HYPGEOM.DIST 函数</h3><p>HYPGEOM.DIST 函数返回超几何分布。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=HYPGEOM.DIST(sample_s,number_sample, population_s, number_pop, cumulative)</span><br></pre></td></tr></table></figure>

<h3 id="LOGNORM-DIST-函数"><a href="#LOGNORM-DIST-函数" class="headerlink" title="LOGNORM.DIST 函数"></a>LOGNORM.DIST 函数</h3><p>LOGNORM.DIST 函数返回对数分布函数。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=LOGNORM.DIST(x,mean,standard_dev,cumulative)</span><br></pre></td></tr></table></figure>

<h3 id="LOGNORM-INV-函数"><a href="#LOGNORM-INV-函数" class="headerlink" title="LOGNORM.INV 函数"></a>LOGNORM.INV 函数</h3><p>LOGNORM.INV 函数返回对数累积分布函数的反函数值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=LOGNORM.INV(probability,mean, standard_dev)</span><br></pre></td></tr></table></figure>

<h3 id="MODE-MULT-函数"><a href="#MODE-MULT-函数" class="headerlink" title="MODE.MULT 函数"></a>MODE.MULT 函数</h3><p>MODE.MULT 函数返回一组数据的众数（出现频率最多的数值）。如果有多个众数，将返回多个结果，因此需将函数以数组形式输入（Ctrl+Shift+Enter）。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=MODE.MULT((number1,[number2],...])</span><br><span class="line">=MODE.MULT((数字1,[数字2],...])</span><br></pre></td></tr></table></figure>

<h3 id="MODE-SNGL-函数"><a href="#MODE-SNGL-函数" class="headerlink" title="MODE.SNGL 函数"></a>MODE.SNGL 函数</h3><p>MODE.SNGL 函数返回一组数据的众数（出现频率最多的数值）。如果有多个众数，返回其中最小的。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=MODE.SNGL(number1,[number2],...])</span><br><span class="line">=MODE.SNGL(数字1,[数字2],...])</span><br></pre></td></tr></table></figure>

<h3 id="NEGBINOM-DIST-函数"><a href="#NEGBINOM-DIST-函数" class="headerlink" title="NEGBINOM.DIST 函数"></a>NEGBINOM.DIST 函数</h3><p>NEGBINOM.DIST 函数返回负二项式分布。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=NEGBINOM.DIST(number_f,number_s, probability_s, cumulative)</span><br></pre></td></tr></table></figure>

<h3 id="NORM-DIST-函数"><a href="#NORM-DIST-函数" class="headerlink" title="NORM.DIST 函数"></a>NORM.DIST 函数</h3><p>NORM.DIST 函数返回指定平均值和标准偏差的正态分布函数。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=NORM.DIST(x,mean,standard_dev,cumulative)</span><br></pre></td></tr></table></figure>

<h3 id="NORM-INV-函数"><a href="#NORM-INV-函数" class="headerlink" title="NORM.INV 函数"></a>NORM.INV 函数</h3><p>NORM.INV 函数返回指定平均值和标准偏差的正态累积分布函数的反函数值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=NORM.INV(probability,mean,standard_dev)</span><br></pre></td></tr></table></figure>

<h3 id="NORM-S-DIST-函数"><a href="#NORM-S-DIST-函数" class="headerlink" title="NORM.S.DIST 函数"></a>NORM.S.DIST 函数</h3><p>NORM.S.DIST 函数返回标准正态分布函数，即平均值为 0，标准偏差为 1。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=NORM.S.DIST(z,cumulative)</span><br></pre></td></tr></table></figure>

<h3 id="NORM-S-INV-函数"><a href="#NORM-S-INV-函数" class="headerlink" title="NORM.S.INV 函数"></a>NORM.S.INV 函数</h3><p>NORM.S.INV 函数返回标准正态累积分布函数的反函数值。标准正态分布函数的平均值为 0，标准偏差为 1。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=NORM.S.INV(probability)</span><br></pre></td></tr></table></figure>

<h3 id="PERCENTILE-EXC-函数"><a href="#PERCENTILE-EXC-函数" class="headerlink" title="PERCENTILE.EXC 函数"></a>PERCENTILE.EXC 函数</h3><p>PERCENTILE.EXC 函数返回一组数值的第 k 个百分点的值。，其中 k 的值在 0 到 1 之间，不包含 0 和 1。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=PERCENTILE.EXC(array,k)</span><br><span class="line">=PERCENTILE.EXC(数组, k)</span><br></pre></td></tr></table></figure>

<h3 id="PERCENTILE-INC-函数"><a href="#PERCENTILE-INC-函数" class="headerlink" title="PERCENTILE.INC 函数"></a>PERCENTILE.INC 函数</h3><p>PERCENTILE.INC 函数返回一组数值的第 k 个百分点的值。，其中 k 的值在 0 到 1 之间，包含 0 和 1。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=PERCENTILE.INC(array,k)</span><br><span class="line">=PERCENTILE.INC(数组, k)</span><br></pre></td></tr></table></figure>

<h3 id="PERCENTRANK-EXC-函数"><a href="#PERCENTRANK-EXC-函数" class="headerlink" title="PERCENTRANK.EXC 函数"></a>PERCENTRANK.EXC 函数</h3><p>PERCENTRANK.EXC 函数返回指定数值在一组数值中的百分比排位。其中百分比的值在 0 到 1 之间，不包含 0 和 1。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=PERCENTRANK.EXC(array,x, [significance])</span><br><span class="line">=PERCENTRANK.EXC(数组, x, [有效位数])</span><br></pre></td></tr></table></figure>

<h3 id="PERCENTRANK-INC-函数"><a href="#PERCENTRANK-INC-函数" class="headerlink" title="PERCENTRANK.INC 函数"></a>PERCENTRANK.INC 函数</h3><p>PERCENTRANK.INC 函数返回指定数值在一组数值中的百分比排位。其中百分比的值在 0 到 1 之间，包含 0 和 1。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=PERCENTRANK.INC(array,x, [significance])</span><br><span class="line">=PERCENTRANK.INC(数组, x, [有效位数])</span><br></pre></td></tr></table></figure>

<h3 id="POISSON-DIST-函数"><a href="#POISSON-DIST-函数" class="headerlink" title="POISSON.DIST 函数"></a>POISSON.DIST 函数</h3><p>POISSON.DIST 函数返回泊松分布。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=POISSON.DIST(x,mean,cumulative)</span><br></pre></td></tr></table></figure>

<h3 id="QUARTILE-EXC-函数"><a href="#QUARTILE-EXC-函数" class="headerlink" title="QUARTILE.EXC 函数"></a>QUARTILE.EXC 函数</h3><p>QUARTILE.EXC 函数返回基于 0 到 1 （不包含 0 和 1）的百分点值对应数据集四分位数。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=QUARTILE.EXC(array,quart)</span><br><span class="line">=QUARTILE.EXC(数据区域, 四分位点)</span><br></pre></td></tr></table></figure>

<h3 id="QUARTILE-INC-函数"><a href="#QUARTILE-INC-函数" class="headerlink" title="QUARTILE.INC 函数"></a>QUARTILE.INC 函数</h3><p>QUARTILE.INC 函数返回基于 0 到 1 （包含 0 和 1）的百分点值对应数据集四分位数。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=QUARTILE.INC(array,quart)</span><br><span class="line">=QUARTILE.INC(数据区域, 四分位点)</span><br></pre></td></tr></table></figure>

<h3 id="RANK-AVG-函数"><a href="#RANK-AVG-函数" class="headerlink" title="RANK.AVG 函数"></a>RANK.AVG 函数</h3><p>RANK.AVG 函数返回指定数字在一列数子中的排名。如果多个数字具有相同的排名，则返回平均排名。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=RANK.AVG(number,ref, [order])</span><br><span class="line">=RANK.AVG(数字, 数字列表, [排序方向])</span><br></pre></td></tr></table></figure>

<h3 id="RANK-EQ-函数"><a href="#RANK-EQ-函数" class="headerlink" title="RANK.EQ 函数"></a>RANK.EQ 函数</h3><p>RANK.EQ 函数返回指定数字在一列数字中的排名。如果多个数字具有相同的排名，则返回最高排名。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=RANK.EQ(number,ref,[order])</span><br><span class="line">=RANK.EQ(数字, 数字列表, [排序方向])</span><br></pre></td></tr></table></figure>

<h3 id="STDEV-P-函数"><a href="#STDEV-P-函数" class="headerlink" title="STDEV.P 函数"></a>STDEV.P 函数</h3><p>STDEV.P 函数计算并返回指定一组数据的总体标准偏差。假定提供的参数是整个总体，非样本。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=STDEV.P(number1,[number2],...])</span><br><span class="line">=STDEV.P(数字1, [数字2], ...)</span><br></pre></td></tr></table></figure>

<h3 id="STDEV-S-函数"><a href="#STDEV-S-函数" class="headerlink" title="STDEV.S 函数"></a>STDEV.S 函数</h3><p>STDEV.S 函数基于样本估算并返回标准偏差。假定提供的参数是总体的样本，非总体。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=STDEV.S(number1,[number2],...])</span><br><span class="line">=STDEV.S(数字1, [数字2], ...)</span><br></pre></td></tr></table></figure>

<h3 id="T-DIST-函数"><a href="#T-DIST-函数" class="headerlink" title="T.DIST 函数"></a>T.DIST 函数</h3><p>T.DIST 函数返回左尾学生 t-分布。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=T.DIST(x,deg_freedom, cumulative)</span><br></pre></td></tr></table></figure>

<h3 id="T-DIST-2T-函数"><a href="#T-DIST-2T-函数" class="headerlink" title="T.DIST.2T 函数"></a>T.DIST.2T 函数</h3><p>T.DIST.2T 函数返回双尾学生 t-分布。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=T.DIST.2T(x,deg_freedom)</span><br></pre></td></tr></table></figure>

<h3 id="T-DIST-RT-函数"><a href="#T-DIST-RT-函数" class="headerlink" title="T.DIST.RT 函数"></a>T.DIST.RT 函数</h3><p>T.DIST.RT 函数返回右尾学生 t-分布。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=T.DIST.RT(x,deg_freedom)</span><br></pre></td></tr></table></figure>

<h3 id="T-INV-函数"><a href="#T-INV-函数" class="headerlink" title="T.INV 函数"></a>T.INV 函数</h3><p>T.INV 函数返回左尾学生 t-分布的反函数。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=T.INV(probability,deg_freedom)</span><br></pre></td></tr></table></figure>

<h3 id="T-INV-2T-函数"><a href="#T-INV-2T-函数" class="headerlink" title="T.INV.2T 函数"></a>T.INV.2T 函数</h3><p>T.INV.2T 函数返回双尾学生 t-分布的反函数。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=T.INV.2T(probability,deg_freedom)</span><br></pre></td></tr></table></figure>

<h3 id="T-TEST-函数"><a href="#T-TEST-函数" class="headerlink" title="T.TEST 函数"></a>T.TEST 函数</h3><p>T.TEST 函数返回与学生 t-检验相关的概率。T.TEST 函数一般用来确定两个样本是否可能来自两个具有相同平均值的基础总体。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=T.TEST(array1,array2,tails,type)</span><br><span class="line">=T.TEST(数组1, 数组2, 分布的尾数, 检验类型)</span><br></pre></td></tr></table></figure>

<h3 id="VAR-P-函数"><a href="#VAR-P-函数" class="headerlink" title="VAR.P 函数"></a>VAR.P 函数</h3><p>VAR.P 函数计算并返回整个样本总体的方差。假定提供的参数是整个总体，非样本。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=VAR.P(number1,[number2],...])</span><br><span class="line">=VAR.P(数字1, [数字2], ...)</span><br></pre></td></tr></table></figure>

<h3 id="VAR-S-函数"><a href="#VAR-S-函数" class="headerlink" title="VAR.S 函数"></a>VAR.S 函数</h3><p>VAR.S 函数基于样本估算并返回方差。假定提供的参数是样本，非总体。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=VAR.S(number1,[number2],...])</span><br><span class="line">=VAR.S(数字1, [数字2], ...)</span><br></pre></td></tr></table></figure>

<h3 id="WEIBULL-DIST-函数"><a href="#WEIBULL-DIST-函数" class="headerlink" title="WEIBULL.DIST 函数"></a>WEIBULL.DIST 函数</h3><p>WEIBULL.DIST 函数返回韦伯（Weibull）分布。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=WEIBULL.DIST(x,alpha, beta, cumulative)</span><br></pre></td></tr></table></figure>

<h3 id="Z-TEST-函数"><a href="#Z-TEST-函数" class="headerlink" title="Z.TEST 函数"></a>Z.TEST 函数</h3><p>Z.TEST 函数返回 z 检验的单尾概率值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=Z.TEST(array,x, [sigma])</span><br><span class="line">=Z.TEST(数组, x, [总体标准偏差])</span><br></pre></td></tr></table></figure>

<p> </p>
<h2 id="数学与三角函数"><a href="#数学与三角函数" class="headerlink" title="数学与三角函数"></a>数学与三角函数</h2><h3 id="AGGREGATE-函数"><a href="#AGGREGATE-函数" class="headerlink" title="AGGREGATE 函数"></a>AGGREGATE 函数</h3><p>AGGREGATE 函数按一定的条件返回一组列表或数据库的合计。在计算合计时，根据提供的参数可以忽略隐藏行、错误值等数据。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">引用形式：=AGGREGATE(function_num, options, ref1,[ref2], …)</span><br><span class="line">数组形式：=AGGREGATE(function_num,options, array, [k])</span><br></pre></td></tr></table></figure>

<h3 id="ISO-CEILING-函数"><a href="#ISO-CEILING-函数" class="headerlink" title="ISO.CEILING 函数"></a>ISO.CEILING 函数</h3><p>ISO.CEILING 函数将数字向上（值增大的方向）舍入到最接近的整数或提供基数的倍数。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=ISO.CEILING(number,[significance])</span><br><span class="line">=ISO.CEILING(数字, [舍入到的倍数])</span><br></pre></td></tr></table></figure>

<h3 id="FLOOR-PRECISE-函数"><a href="#FLOOR-PRECISE-函数" class="headerlink" title="FLOOR.PRECISE 函数"></a>FLOOR.PRECISE 函数</h3><p>FLOOR.PRECISE 函数将数字向下舍入到整数或者以指定基数的倍数向下舍入。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=FLOOR.PRECISE(number,[significance])</span><br><span class="line">=FLOOR.PRECISE(数字, [舍入倍数])</span><br></pre></td></tr></table></figure>

<h3 id="CEILING-PRECISE-函数"><a href="#CEILING-PRECISE-函数" class="headerlink" title="CEILING.PRECISE 函数"></a>CEILING.PRECISE 函数</h3><p>CEILING.PRECISE 函数将数字向上舍入到整数或者以指定基数的倍数向上舍入（沿绝对值增大的方向）。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=CEILING.PRECISE(number, [significance])</span><br><span class="line">=CEILING.PRECISE(数字, [舍入倍数])</span><br></pre></td></tr></table></figure>



      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-2010-new-functions/" data-id="clatcwf9s00euxcq6a72xgt9r" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-excel-2010-realtime-paste" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-2010-realtime-paste/" class="article-date">
  <time datetime="2022-11-23T07:04:54.100Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/">基础</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/">新增功能和函数</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/Excel-2010/">Excel 2010</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-2010-realtime-paste/">Excel 2010 – 粘贴时可以实时预览</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <p>当在 Excel 中进行粘贴时，在插入内容前可以实时预览粘贴后的内容和格式。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_bcbea8dc2463a348d5b837d0d199e21e.gif"></p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-2010-realtime-paste/" data-id="clatcwf9w00ewxcq6fmld8dk1" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-excel-2010-search-filter" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-2010-search-filter/" class="article-date">
  <time datetime="2022-11-23T07:04:54.100Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/">基础</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/">新增功能和函数</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/Excel-2010/">Excel 2010</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-2010-search-filter/">Excel 2010 – 新的筛选选项 ▶ 搜索筛选</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <p>在 Excel 2010 及以后的版本中，使用自动筛选、表格筛选、数据透视表筛选或数据透视图筛选时，可以用新的搜索筛选框，输入目标内容的一部分，快速搜索并筛选。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_c7fbe9cb565016c7dd50c7d375d8f3c9.png"></p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-2010-search-filter/" data-id="clatcwf9z00eyxcq6g97d8byb" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-excel-2010-slicer" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-2010-slicer/" class="article-date">
  <time datetime="2022-11-23T07:04:54.100Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/">基础</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/">新增功能和函数</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/Excel-2010/">Excel 2010</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-2010-slicer/">Excel 2010 – 新增切片器</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <p>切片器是易于使用的，用来筛选数据透视表的图形化按钮控件，无需打开筛选菜单。切片器可以快速对数据进行筛选，并且可以显示当前数据的筛选状态。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_5b5bcfefe681c0ab10f39739cf129912.png"></p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-2010-slicer/" data-id="clatcwfa700f2xcq62h895lof" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-excel-2013-multi-window" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-2013-multi-window/" class="article-date">
  <time datetime="2022-11-23T07:04:54.100Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/">基础</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/">新增功能和函数</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/Excel-2013/">Excel 2013</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-2013-multi-window/">Excel 2013 – 工作簿可独立窗口显示</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <p>在 Excel 2013 中，每一个工作簿都以独立窗口显示，可同时方便的编辑多个工作簿。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_2b02bedb2e285462615f4fa77898eadd.png"></p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-2013-multi-window/" data-id="clatcwfa900f4xcq6db4kf7pl" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-excel-2013-quick-analysis" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-2013-quick-analysis/" class="article-date">
  <time datetime="2022-11-23T07:04:54.100Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/">基础</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/">新增功能和函数</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/Excel-2013/">Excel 2013</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-2013-quick-analysis/">Excel 2013 – 新增快速分析</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <p>使用快速分析工具，可通过一些最有用的 Excel 工具（例如，格式、图表、汇总等）快速、方便地分析数据。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_1a1fa9c46fbf85edc5f53ebe1f459e5b.png"></p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-2013-quick-analysis/" data-id="clatcwfae00f8xcq6f9np9a6d" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-excel-2013-quick-fill" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-2013-quick-fill/" class="article-date">
  <time datetime="2022-11-23T07:04:54.100Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/">基础</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/">新增功能和函数</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/Excel-2013/">Excel 2013</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-2013-quick-fill/">Excel 2013 – 新增快速填充</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <p>使用快速填充命令，自动填充值。填充时会根据已有的示例进行模式识别，然后根据此种模式填充其他所选区域中剩余的单元格。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_2a632e646e02393efb83ee87086fe137.gif"></p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-2013-quick-fill/" data-id="clatcwfak00fcxcq69xx12e7h" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-excel-2013-recommended-chart" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-2013-recommended-chart/" class="article-date">
  <time datetime="2022-11-23T07:04:54.100Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/">基础</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/">新增功能和函数</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/Excel-2013/">Excel 2013</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-2013-recommended-chart/">Excel 2013 – 新增推荐的图表</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <p>使用推荐的图表功能，Excel 根据数据推荐最适合的图表，而无需实际创建图表就可以预览图表的效果。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_e1d99e3a97c96c7098a582bffa75b770.png"></p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-2013-recommended-chart/" data-id="clatcwfan00fexcq6c15u0ama" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-excel-2013-more-chart-label" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-2013-more-chart-label/" class="article-date">
  <time datetime="2022-11-23T07:04:54.084Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/">基础</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/">新增功能和函数</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/Excel-2013/">Excel 2013</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-2013-more-chart-label/">Excel 2013 – 丰富的图表数据标签</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <p>在 Excel 2013 中，可以对图表数据标签形状进行自定义。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_a42315b5afa10f3444bfe15cb60e92de.png"></p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-2013-more-chart-label/" data-id="clatcwfa200f0xcq6axm424nx" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-excel-2013-new-functions" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-2013-new-functions/" class="article-date">
  <time datetime="2022-11-23T07:04:54.084Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/">基础</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/">新增功能和函数</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/Excel-2013/">Excel 2013</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-2013-new-functions/">Excel 2013 – 新增函数</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <h2 id="日期和时间函数"><a href="#日期和时间函数" class="headerlink" title="日期和时间函数"></a>日期和时间函数</h2><h3 id="DAYS-函数"><a href="#DAYS-函数" class="headerlink" title="DAYS 函数"></a>DAYS 函数</h3><p>DAYS 函数返回两个日期之间的天数。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=DAYS(end_date, start_date)</span><br><span class="line">=DAYS(结束日期, 开始日期)</span><br></pre></td></tr></table></figure>

<h3 id="ISOWEEKNUM-函数"><a href="#ISOWEEKNUM-函数" class="headerlink" title="ISOWEEKNUM 函数"></a>ISOWEEKNUM 函数</h3><p>ISOWEEKNUM函数返回指定日期在全年中的 ISO 周数。ISO周日历系统是ISO 8601日期和时间标准的一部分，是一种闰周历系统。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=ISOWEEKNUM(date)</span><br><span class="line">=ISOWEEKNUM(日期)</span><br></pre></td></tr></table></figure>

<p> </p>
<h2 id="工程函数"><a href="#工程函数" class="headerlink" title="工程函数"></a>工程函数</h2><h3 id="BITAND-函数"><a href="#BITAND-函数" class="headerlink" title="BITAND 函数"></a>BITAND 函数</h3><p>BITAND 函数返回两个数的按位进行“与”（AND）运算后的结果。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=BITAND( number1, number2)</span><br></pre></td></tr></table></figure>

<h3 id="BITLSHIFT-函数"><a href="#BITLSHIFT-函数" class="headerlink" title="BITLSHIFT 函数"></a>BITLSHIFT 函数</h3><p>BITLSHIFT 函数返回一个数向左移动指定位数后的数值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=BITLSHIFT(number, shift_amount)</span><br></pre></td></tr></table></figure>

<h3 id="BITOR-函数"><a href="#BITOR-函数" class="headerlink" title="BITOR 函数"></a>BITOR 函数</h3><p>BITOR 函数返回两个数的按位进行“或”（OR）运算后的结果。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=BITOR( number1, number2)</span><br></pre></td></tr></table></figure>

<h3 id="BITRSHIFT-函数"><a href="#BITRSHIFT-函数" class="headerlink" title="BITRSHIFT 函数"></a>BITRSHIFT 函数</h3><p>BITRSHIFT 函数返回一个数向右移动指定位数后的数值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=BITRSHIFT(number, shift_amount)</span><br></pre></td></tr></table></figure>

<h3 id="BITXOR-函数"><a href="#BITXOR-函数" class="headerlink" title="BITXOR 函数"></a>BITXOR 函数</h3><p>BITXOR 函数返回两个数的按位进行“异或”（XOR）运算后的结果。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=BITXOR( number1, number2)</span><br></pre></td></tr></table></figure>

<h3 id="IMCOSH-函数"><a href="#IMCOSH-函数" class="headerlink" title="IMCOSH 函数"></a>IMCOSH 函数</h3><p>IMCOSH 函数返回以 x + yi 或 x + yj 文本格式表示的复数的双曲余弦值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=IMCOSH(inumber)</span><br></pre></td></tr></table></figure>

<h3 id="IMCOT-函数"><a href="#IMCOT-函数" class="headerlink" title="IMCOT 函数"></a>IMCOT 函数</h3><p>IMCOT 函数返回以 x + yi 或 x + yj 文本格式表示的复数的余切值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=IMCOT(inumber)</span><br></pre></td></tr></table></figure>

<h3 id="IMCSC-函数"><a href="#IMCSC-函数" class="headerlink" title="IMCSC 函数"></a>IMCSC 函数</h3><p>IMCSC 函数返回以 x + yi 或 x + yj 文本格式表示的复数的余割值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=IMCSC(inumber)</span><br></pre></td></tr></table></figure>

<h3 id="IMCSCH-函数"><a href="#IMCSCH-函数" class="headerlink" title="IMCSCH 函数"></a>IMCSCH 函数</h3><p>IMCSCH 函数返回以 x + yi 或 x + yj 文本格式表示的复数的双曲余割值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=IMCSCH(inumber)</span><br></pre></td></tr></table></figure>

<h3 id="IMSEC-函数"><a href="#IMSEC-函数" class="headerlink" title="IMSEC 函数"></a>IMSEC 函数</h3><p>IMSEC 函数返回以 x + yi 或 x + yj 文本格式表示的复数的正割值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=IMSEC(inumber)</span><br></pre></td></tr></table></figure>

<h3 id="IMSEH-函数"><a href="#IMSEH-函数" class="headerlink" title="IMSEH 函数"></a>IMSEH 函数</h3><p>IMSEH 函数返回以 x + yi 或 x + yj 文本格式表示的复数的双曲正割值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=IMSECH(inumber)</span><br></pre></td></tr></table></figure>

<h3 id="IMSINH-函数"><a href="#IMSINH-函数" class="headerlink" title="IMSINH 函数"></a>IMSINH 函数</h3><p>IMSINH 函数返回以 x + yi 或 x + yj 文本格式表示的复数的双曲正弦值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=IMSINH(inumber)</span><br></pre></td></tr></table></figure>

<h3 id="IMTAN-函数"><a href="#IMTAN-函数" class="headerlink" title="IMTAN 函数"></a>IMTAN 函数</h3><p>IMTAN 函数返回以 x + yi 或 x + yj 文本格式表示的复数的正切值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=IMTAN(inumber</span><br></pre></td></tr></table></figure>

<p> </p>
<h2 id="财务函数"><a href="#财务函数" class="headerlink" title="财务函数"></a>财务函数</h2><h3 id="PDURATION-函数"><a href="#PDURATION-函数" class="headerlink" title="PDURATION 函数"></a>PDURATION 函数</h3><p>此函数为财务函数中计算持续期的函数，返回投资到达指定值所需的期数。函数名由Period（时期）+Duration（期间）两个单词组成。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=PDURATION(rate, pv, fv)</span><br><span class="line">=PDURATION(每期利率, 现值, 未来值)</span><br></pre></td></tr></table></figure>

<h3 id="RRI-函数"><a href="#RRI-函数" class="headerlink" title="RRI 函数"></a>RRI 函数</h3><p>此函数为财务函数中计算利息率值的函数，返回投资增长的等效利率。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=RRI(nper,pv, fv)</span><br><span class="line">=RRI(投资期数, 现值, 未来值)</span><br></pre></td></tr></table></figure>

<p> </p>
<h2 id="信息函数"><a href="#信息函数" class="headerlink" title="信息函数"></a>信息函数</h2><h3 id="ISFORMULA-函数"><a href="#ISFORMULA-函数" class="headerlink" title="ISFORMULA 函数"></a>ISFORMULA 函数</h3><p>ISFORMULA 函数检查指定的单元格是否包含公式。如果包含公式，则返回 TRUE；否则，返回 FALSE。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=ISFORMULA(reference )</span><br></pre></td></tr></table></figure>

<h3 id="SHEET-函数"><a href="#SHEET-函数" class="headerlink" title="SHEET 函数"></a>SHEET 函数</h3><p>SHEET 函数返回指定工作表的工作表编号。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=SHEET([value])</span><br></pre></td></tr></table></figure>

<h3 id="SHEETS-函数"><a href="#SHEETS-函数" class="headerlink" title="SHEETS 函数"></a>SHEETS 函数</h3><p>SHEETS 函数返回引用中的工作表数量。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=SHEETS(reference)</span><br></pre></td></tr></table></figure>

<p> </p>
<h2 id="逻辑函数"><a href="#逻辑函数" class="headerlink" title="逻辑函数"></a>逻辑函数</h2><h3 id="IFNA-函数"><a href="#IFNA-函数" class="headerlink" title="IFNA 函数"></a>IFNA 函数</h3><p>IFNA 函数判断提供的初始条件的结果是否返回 #N&#x2F;A 型错误，如果返回 #N&#x2F;A 型错误，则返回提供的第二个参数；否则返回初始条件或其计算结果。函数名由If（如果）+ #N&#x2F;A（Excel 的值不可用错误）等部分组成。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=IFNA(value, value_if_na)</span><br><span class="line">=IFNA(条件, 条件结果为#N/A型错误时的返回值)</span><br></pre></td></tr></table></figure>

<h3 id="XOR-函数"><a href="#XOR-函数" class="headerlink" title="XOR 函数"></a>XOR 函数</h3><p>XOR 函数返回提供的所有参数的异或逻辑运算值。函数名由 Exclusive（独家）+ Or（或者）等部分组成。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=XOR(logical1, [logical2],…)</span><br><span class="line">=XOR(逻辑值1, [逻辑值2],…)</span><br></pre></td></tr></table></figure>

<p> </p>
<h2 id="查找与引用函数"><a href="#查找与引用函数" class="headerlink" title="查找与引用函数"></a>查找与引用函数</h2><h3 id="FORMULATEXT-函数"><a href="#FORMULATEXT-函数" class="headerlink" title="FORMULATEXT 函数"></a>FORMULATEXT 函数</h3><p>FORMULATEXT 函数以文本格式返回指定单元格的公式。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=FORMULATEXT(reference)</span><br><span class="line">=FORMULATEXT(单元格引用)</span><br></pre></td></tr></table></figure>

<p> </p>
<h2 id="数学与三角函数"><a href="#数学与三角函数" class="headerlink" title="数学与三角函数"></a>数学与三角函数</h2><h3 id="ACOT-函数"><a href="#ACOT-函数" class="headerlink" title="ACOT 函数"></a>ACOT 函数</h3><p>ACOT 函数返回数字的反余切值的主值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=ACOT(number)</span><br><span class="line">=ACOT(数字)</span><br></pre></td></tr></table></figure>

<h3 id="ACOTH-函数"><a href="#ACOTH-函数" class="headerlink" title="ACOTH 函数"></a>ACOTH 函数</h3><p>ACOTH 函数返回数字的反双曲余切值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=ACOTH(number)</span><br><span class="line">=ACOTH(数字)</span><br></pre></td></tr></table></figure>

<h3 id="ARABIC-函数"><a href="#ARABIC-函数" class="headerlink" title="ARABIC 函数"></a>ARABIC 函数</h3><p>ARABIC 函数将罗马数字转换为阿拉伯数字。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=ARABIC(text)</span><br><span class="line">=ARABIC(字符串)</span><br></pre></td></tr></table></figure>

<h3 id="BASE-函数"><a href="#BASE-函数" class="headerlink" title="BASE 函数"></a>BASE 函数</h3><p>BASE 函数将数字转换为以指定基数（二进制、十六进制等）的数字，返回其文本表示。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=BASE(Number, Radix,[Min_length])</span><br><span class="line">=BASE(数字, 基数, [字符串最小长度])</span><br></pre></td></tr></table></figure>

<h3 id="CEILING-MATH-函数"><a href="#CEILING-MATH-函数" class="headerlink" title="CEILING.MATH 函数"></a>CEILING.MATH 函数</h3><p>CEILING.MATH 函数将数字向上舍入到整数或者以指定基数的倍数向上舍入。对于负数，可以控制舍入方向。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=CEILING.MATH(number,[significance],  [mode])</span><br><span class="line">=CEILING.MATH(数字, [舍入倍数], [方向])</span><br></pre></td></tr></table></figure>

<h3 id="COMBINA-函数"><a href="#COMBINA-函数" class="headerlink" title="COMBINA 函数"></a>COMBINA 函数</h3><p>COMBINA 函数返回指定数量元素的总组合数（包含重复项）。可以指定组合元素数量。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=COMBINA(number,number_chosen)</span><br><span class="line">=COMBINA(数量, 选中元素数量)</span><br></pre></td></tr></table></figure>

<h3 id="COT-函数"><a href="#COT-函数" class="headerlink" title="COT 函数"></a>COT 函数</h3><p>COT 函数返回角度的余切值，提供的角度以弧度表示。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=COT(number)</span><br><span class="line">=COT(角度)</span><br></pre></td></tr></table></figure>

<h3 id="COTH-函数"><a href="#COTH-函数" class="headerlink" title="COTH 函数"></a>COTH 函数</h3><p>COTH 函数返回角度的双曲余切值，提供的角度以弧度表示。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=COTH(number)</span><br><span class="line">=COTH(角度)</span><br></pre></td></tr></table></figure>

<h3 id="CSC-函数"><a href="#CSC-函数" class="headerlink" title="CSC 函数"></a>CSC 函数</h3><p>CSC 函数返回角度的余割值，角度以弧度表示。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=CSC(number)</span><br><span class="line">=CSC(角度)</span><br></pre></td></tr></table></figure>

<h3 id="CSCH-函数"><a href="#CSCH-函数" class="headerlink" title="CSCH 函数"></a>CSCH 函数</h3><p>CSCH 函数返回角度的双曲余割值，角度以弧度表示。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=CSCH(number)</span><br><span class="line">=CSCH(角度)</span><br></pre></td></tr></table></figure>

<h3 id="DECIMAL-函数"><a href="#DECIMAL-函数" class="headerlink" title="DECIMAL 函数"></a>DECIMAL 函数</h3><p>DECIMAL 函数将按指定基数表示的文本数字转换为十进制数字。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=DECIMAL(text, radix)</span><br><span class="line">=DECIMAL(文本格式数字, 基数)</span><br></pre></td></tr></table></figure>

<h3 id="FLOOR-MATH-函数"><a href="#FLOOR-MATH-函数" class="headerlink" title="FLOOR.MATH 函数"></a>FLOOR.MATH 函数</h3><p>FLOOR.MATH 函数将数字向下舍入（沿绝对值减小的方向）到最近的指定基数的倍数，可以指定负数舍入方向。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=FLOOR.MATH( number, [significance], [mode] )</span><br><span class="line">=FLOOR.MATH( 数字, [倍数], [方向] )</span><br></pre></td></tr></table></figure>

<h3 id="MUNIT-函数"><a href="#MUNIT-函数" class="headerlink" title="MUNIT 函数"></a>MUNIT 函数</h3><p>MUNIT 函数返回指定维度的单位矩阵。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=MUNIT(dimension)</span><br><span class="line">=MUNIT(维度)</span><br></pre></td></tr></table></figure>

<h3 id="SEC-函数"><a href="#SEC-函数" class="headerlink" title="SEC 函数"></a>SEC 函数</h3><p>SEC 函数返回角度的正割值，提供的角度以弧度表示。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=SEC(number)</span><br><span class="line">=SEC(角度)</span><br></pre></td></tr></table></figure>

<h3 id="SECH-函数"><a href="#SECH-函数" class="headerlink" title="SECH 函数"></a>SECH 函数</h3><p>SECH 函数返回角度的双曲正割值，提供的角度以弧度表示。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=SECH(number)</span><br><span class="line">=SECH(角度)</span><br></pre></td></tr></table></figure>

<p> </p>
<h2 id="统计函数"><a href="#统计函数" class="headerlink" title="统计函数"></a>统计函数</h2><h3 id="BINOM-DIST-RANGE-函数"><a href="#BINOM-DIST-RANGE-函数" class="headerlink" title="BINOM.DIST.RANGE 函数"></a>BINOM.DIST.RANGE 函数</h3><p>BINOM.DIST.RANGE 函数使用二项式分布返回试验结果的概率。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=BINOM.DIST.RANGE(trials,probability_s,number_s,[number_s2])</span><br></pre></td></tr></table></figure>

<h3 id="GAMMA-函数"><a href="#GAMMA-函数" class="headerlink" title="GAMMA 函数"></a>GAMMA 函数</h3><p>GAMMA 函数对于指定数值，返回其 GAMMA 函数值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=GAMMA(number)</span><br><span class="line">=GAMMA(数字)</span><br></pre></td></tr></table></figure>

<h3 id="GAUSS-函数"><a href="#GAUSS-函数" class="headerlink" title="GAUSS 函数"></a>GAUSS 函数</h3><p>GAUSS 函数返回标准正态分布的比累积分布函数小 0.5 的值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=GAUSS(number)</span><br></pre></td></tr></table></figure>

<h3 id="PERMUTATIONA-函数"><a href="#PERMUTATIONA-函数" class="headerlink" title="PERMUTATIONA 函数"></a>PERMUTATIONA 函数</h3><p>PERMUTATIONA 函数返回从给定数目的对象中选取指定数量对象（含重复）的排列数。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=PERMUTATIONA(number,number-chosen)</span><br><span class="line">=PERMUTATIONA(对象总数, 选取对象数量)</span><br></pre></td></tr></table></figure>

<h3 id="PHI-函数"><a href="#PHI-函数" class="headerlink" title="PHI 函数"></a>PHI 函数</h3><p>PHI 函数返回标准正态分布的密度函数值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=PHI(x)</span><br></pre></td></tr></table></figure>

<h3 id="SKEW-P-函数"><a href="#SKEW-P-函数" class="headerlink" title="SKEW.P 函数"></a>SKEW.P 函数</h3><p>SKEW.P 函数返回基于样本总体分布的偏斜度。返回值为正数，表示正偏斜；返回值为负数，表示负偏斜。偏斜度表明分布相对于平均值的不对称程度。正偏斜度表明分布的不对称尾部趋向于更多正值。 负偏斜度表明分布的不对称尾部趋向于更多负值。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=SKEW.P(number1, [number2], ...)</span><br><span class="line">=SKEW.P(数字1, [数字2], ...)</span><br></pre></td></tr></table></figure>

<p> </p>
<h2 id="文本函数"><a href="#文本函数" class="headerlink" title="文本函数"></a>文本函数</h2><h3 id="NUMBERVALUE-函数"><a href="#NUMBERVALUE-函数" class="headerlink" title="NUMBERVALUE 函数"></a>NUMBERVALUE 函数</h3><p>NUMBERVALUE 函数将文本以与区域设置无关的方式转换为数字。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=NUMBERVALUE(text, [decimal_separator], [group_separator])</span><br><span class="line">=NUMBERVALUE(文本, [整数小时分隔符], [组分隔符 ])</span><br></pre></td></tr></table></figure>

<h3 id="UNICHAR-函数"><a href="#UNICHAR-函数" class="headerlink" title="UNICHAR 函数"></a>UNICHAR 函数</h3><p>UNICHAR 函数返回给定数值引用的Unicode 字符。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=UNICHAR(number)</span><br><span class="line">=UNICHAR(数字)</span><br></pre></td></tr></table></figure>

<h3 id="UNICODE-函数"><a href="#UNICODE-函数" class="headerlink" title="UNICODE 函数"></a>UNICODE 函数</h3><p>UNICODE 函数返回对应于文本的第一个字符的数字代码。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">=UNICODE(text)</span><br><span class="line">=UNICODE(文本)</span><br></pre></td></tr></table></figure>

<p> </p>
<h2 id="Web-函数"><a href="#Web-函数" class="headerlink" title="Web 函数"></a>Web 函数</h2><h3 id="ENCODEURL-函数"><a href="#ENCODEURL-函数" class="headerlink" title="ENCODEURL 函数"></a>ENCODEURL 函数</h3><p>ENCODEURL 函数返回 URL 编码的字符串。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=ENCODEURL（text)</span><br></pre></td></tr></table></figure>

<h3 id="FILTERXML-函数"><a href="#FILTERXML-函数" class="headerlink" title="FILTERXML 函数"></a>FILTERXML 函数</h3><p>FILTERXML 函数通过使用指定的 XPath，返回 XML 内容中的特定数据。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=FILTERXML(xml, xpath)</span><br></pre></td></tr></table></figure>

<h3 id="WEBSERVICE-函数"><a href="#WEBSERVICE-函数" class="headerlink" title="WEBSERVICE 函数"></a>WEBSERVICE 函数</h3><p>WEBSERVICE 函数从 Web 服务器返回数据。</p>
<figure class="highlight plaintext"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">=WEBSERVICE(url])</span><br></pre></td></tr></table></figure>

<p> </p>
<p> </p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-2013-new-functions/" data-id="clatcwfab00f6xcq675af8zcu" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  


  <nav id="page-nav">
    
    <a class="extend prev" rel="prev" href="/study-excel/page/73/">&amp;laquo; 上一页</a><a class="page-number" href="/study-excel/">1</a><span class="space">&hellip;</span><a class="page-number" href="/study-excel/page/72/">72</a><a class="page-number" href="/study-excel/page/73/">73</a><span class="page-number current">74</span><a class="page-number" href="/study-excel/page/75/">75</a><a class="page-number" href="/study-excel/page/76/">76</a><span class="space">&hellip;</span><a class="page-number" href="/study-excel/page/94/">94</a><a class="extend next" rel="next" href="/study-excel/page/75/">下一页 &amp;raquo;</a>
  </nav>

</section>
        
          <aside id="sidebar">
  
    
  <div class="widget-wrap">
    <h3 class="widget-title">分类</h3>
    <div class="widget">
      <ul class="category-list"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/VBA/">VBA</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%85%AC%E5%BC%8F/">公式</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%87%BD%E6%95%B0/">函数</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/">函数与公式基础</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/%E5%9F%BA%E7%A1%80/">基础</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/%E5%9F%BA%E7%A1%80/%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/">公式基础</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/%E5%9F%BA%E7%A1%80/%E5%85%AC%E5%BC%8F%E9%94%99%E8%AF%AF/">公式错误</a></li></ul></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%8A%9F%E8%83%BD/">功能</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%8A%9F%E8%83%BD%E5%8C%BA/">功能区</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%8A%9F%E8%83%BD%E5%8C%BA/%E5%9F%BA%E7%A1%80/">基础</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%8A%9F%E8%83%BD%E5%8C%BA/%E5%9F%BA%E7%A1%80/%E5%85%AC%E5%BC%8F/">公式</a></li></ul></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%8D%95%E5%85%83%E6%A0%BC%E5%BC%95%E7%94%A8/">单元格引用</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%8D%95%E5%85%83%E6%A0%BC%E5%BC%95%E7%94%A8/%E5%9F%BA%E7%A1%80/">基础</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%8D%95%E5%85%83%E6%A0%BC%E5%BC%95%E7%94%A8/%E5%9F%BA%E7%A1%80/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/">函数与公式基础</a></li></ul></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/">基本概念</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/%E5%9F%BA%E7%A1%80/">基础</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/%E5%9F%BA%E7%A1%80/%E4%BD%BF%E7%94%A8-Excel/">使用 Excel</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/%E5%9F%BA%E7%A1%80/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F/">函数与公式</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/%E5%9F%BA%E7%A1%80/%E5%8D%95%E5%85%83%E6%A0%BC/">单元格</a></li></ul></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/">基本设置</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/%E5%9F%BA%E7%A1%80/">基础</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/%E5%9F%BA%E7%A1%80/%E4%BF%9D%E5%AD%98%E8%AE%BE%E7%BD%AE/">保存设置</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/%E5%9F%BA%E7%A1%80/%E5%85%AC%E5%BC%8F%E8%AE%BE%E7%BD%AE/">公式设置</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/%E5%9F%BA%E7%A1%80/%E5%85%B6%E4%BB%96%E8%AE%BE%E7%BD%AE/">其他设置</a></li></ul></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/">基础</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/">基础操作</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E4%BF%9D%E6%8A%A4/">保护</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%A4%8D%E5%88%B6%E5%85%AC%E5%BC%8F/">复制公式</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%A4%8D%E5%88%B6%E5%85%AC%E5%BC%8F/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/">函数与公式基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%AE%A1%E9%98%85/">审阅</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%AE%A1%E9%98%85/%E5%8A%9F%E8%83%BD%E5%8C%BA/">功能区</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B7%A5%E4%BD%9C%E7%95%8C%E9%9D%A2/">工作界面</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B7%A5%E4%BD%9C%E7%95%8C%E9%9D%A2/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/">基本概念</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B8%B8%E8%A7%81%E6%9C%AF%E8%AF%AD/">常见术语</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B8%B8%E8%A7%81%E6%9C%AF%E8%AF%AD/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/">基本概念</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B8%B8%E8%A7%84%E8%AE%BE%E7%BD%AE/">常规设置</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B8%B8%E8%A7%84%E8%AE%BE%E7%BD%AE/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/">基本设置</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%BC%80%E5%A7%8B/">开始</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%BC%80%E5%A7%8B/%E5%8A%9F%E8%83%BD%E5%8C%BA/">功能区</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%8F%92%E5%85%A5/">插入</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%8F%92%E5%85%A5/%E5%8A%9F%E8%83%BD%E5%8C%BA/">功能区</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%95%B0%E6%8D%AE/">数据</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%95%B0%E6%8D%AE/%E5%8A%9F%E8%83%BD%E5%8C%BA/">功能区</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/">新增功能和函数</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/Excel-2007/">Excel 2007</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/Excel-2010/">Excel 2010</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/Excel-2013/">Excel 2013</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/Excel-2016/">Excel 2016</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%A0%A1%E5%AF%B9%E8%AE%BE%E7%BD%AE/">校对设置</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%A0%A1%E5%AF%B9%E8%AE%BE%E7%BD%AE/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/">基本设置</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E7%BC%96%E5%86%99%E5%85%AC%E5%BC%8F/">编写公式</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E7%BC%96%E5%86%99%E5%85%AC%E5%BC%8F/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/">函数与公式基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E7%BC%96%E8%BE%91%E5%85%AC%E5%BC%8F/">编辑公式</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E7%BC%96%E8%BE%91%E5%85%AC%E5%BC%8F/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/">函数与公式基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E8%A7%86%E5%9B%BE/">视图</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E8%A7%86%E5%9B%BE/%E5%8A%9F%E8%83%BD%E5%8C%BA/">功能区</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E9%A1%B5%E9%9D%A2%E5%B8%83%E5%B1%80/">页面布局</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E9%A1%B5%E9%9D%A2%E5%B8%83%E5%B1%80/%E5%8A%9F%E8%83%BD%E5%8C%BA/">功能区</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E9%AB%98%E7%BA%A7%E8%AE%BE%E7%BD%AE/">高级设置</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E9%AB%98%E7%BA%A7%E8%AE%BE%E7%BD%AE/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/">基本设置</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E9%BC%A0%E6%A0%87%E6%8C%87%E9%92%88/">鼠标指针</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E9%BC%A0%E6%A0%87%E6%8C%87%E9%92%88/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/">基本概念</a></li></ul></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/">基础操作</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E5%A4%8D%E5%88%B6%E4%B8%8E%E7%B2%98%E8%B4%B4/">复制与粘贴</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E5%A4%8D%E5%88%B6%E4%B8%8E%E7%B2%98%E8%B4%B4/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E6%89%93%E5%8D%B0/">打印</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E6%89%93%E5%8D%B0/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E6%9F%A5%E6%89%BE%E4%B8%8E%E9%80%89%E6%8B%A9/">查找与选择</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E6%9F%A5%E6%89%BE%E4%B8%8E%E9%80%89%E6%8B%A9/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E5%8D%95%E5%85%83%E6%A0%BC%E6%A0%BC%E5%BC%8F/">编辑单元格格式</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E5%8D%95%E5%85%83%E6%A0%BC%E6%A0%BC%E5%BC%8F/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E5%B7%A5%E4%BD%9C%E8%A1%A8/">编辑工作表</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E5%B7%A5%E4%BD%9C%E8%A1%A8/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E5%B7%A5%E4%BD%9C%E8%A1%A8%E5%8C%BA%E5%9F%9F/">编辑工作表区域</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E5%B7%A5%E4%BD%9C%E8%A1%A8%E5%8C%BA%E5%9F%9F/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E6%95%B0%E5%AD%97%E6%A0%BC%E5%BC%8F/">编辑数字格式</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E6%95%B0%E5%AD%97%E6%A0%BC%E5%BC%8F/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E9%BC%A0%E6%A0%87%E6%93%8D%E4%BD%9C/">鼠标操作</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E9%BC%A0%E6%A0%87%E6%93%8D%E4%BD%9C/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%BF%AB%E6%8D%B7%E9%94%AE/">快捷键</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E9%97%AE%E9%A2%98/">问题</a></li></ul>
    </div>
  </div>


  
    

  
    
  
    
  <div class="widget-wrap">
    <h3 class="widget-title">归档</h3>
    <div class="widget">
      <ul class="archive-list"><li class="archive-list-item"><a class="archive-list-link" href="/study-excel/archives/2022/11/">十一月 2022</a></li></ul>
    </div>
  </div>


  
    
  <div class="widget-wrap">
    <h3 class="widget-title">最新文章</h3>
    <div class="widget">
      <ul>
        
          <li>
            <a href="/study-excel/excel-coupdaybs-function/">Excel COUPDAYBS 函数</a>
          </li>
        
          <li>
            <a href="/study-excel/excel-coupdays-function/">Excel COUPDAYS 函数</a>
          </li>
        
          <li>
            <a href="/study-excel/excel-coupdaysnc-function/">Excel COUPDAYSNC 函数</a>
          </li>
        
          <li>
            <a href="/study-excel/excel-coupncd-function/">Excel COUPNCD 函数</a>
          </li>
        
          <li>
            <a href="/study-excel/excel-coupnum-function/">Excel COUPNUM 函数</a>
          </li>
        
      </ul>
    </div>
  </div>

  
</aside>
        
      </div>
      <footer id="footer">
  
  <div class="outer">
    <div id="footer-info" class="inner">
      &copy; 2022 lijile<br>
      Powered by <a href="http://hexo.io/" target="_blank">Hexo</a>
    </div>
  </div>
</footer>
    </div>
    <nav id="mobile-nav">
  
    <a href="/study-excel/" class="mobile-nav-link">Home</a>
  
    <a href="/study-excel/archives" class="mobile-nav-link">Archives</a>
  
</nav>
    

<script src="//ajax.googleapis.com/ajax/libs/jquery/2.0.3/jquery.min.js"></script>


  
<link rel="stylesheet" href="/study-excel/fancybox/jquery.fancybox.css">

  
<script src="/study-excel/fancybox/jquery.fancybox.pack.js"></script>




<script src="/study-excel/js/script.js"></script>




  </div>
</body>
</html>